package snapex.expense.mapper.ext;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

public class HtcExpenseSqlProvider implements ProviderMethodResolver{
	
	public static String insertExpense() {
		return "insert into FINS_EXPENSE$t_expense (expense_id, status, next_approver, last_approver, staff_id, extension_no, site_id, total_amount, expense_cash_advance_amount, submitted_date, confirmed_date, clarity_project_id, clarity_project_name, customer_cost_centre_name, customer_cost_centre_no, billable, customer_cost_centre_mandatory) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
	}
	
	public static String insertExpenseDetail() {
		return "insert into FINS_EXPENSE$t_expense_detail (expense_detail_id, expense_id, occur_date, description, currency, amount, purpose_id, id, list_index) values (?, ?, ?, ?, ?, ?, ?, ?, ?)";
	}
	
	public static String insertExpenseMail() {
		return "insert into FINS_EXPENSE$t_expense_mail (expense_id, status) values (?, ?)";
	}
}
